object MalzemeFisleriF: TMalzemeFisleriF
  Tag = 88
  Left = 108
  Top = 81
  Width = 1010
  Height = 642
  Caption = 'Malzeme Fi'#351'leri'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  Menu = MainMenu1
  OldCreateOrder = False
  Position = poDefaultPosOnly
  OnClose = FormClose
  OnCreate = FormCreate
  OnKeyDown = FormKeyDown
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  DesignSize = (
    1002
    596)
  PixelsPerInch = 96
  TextHeight = 14
  object Label6: TLabel
    Left = 771
    Top = 140
    Width = 221
    Height = 17
    Alignment = taCenter
    AutoSize = False
    Caption = 'Hatal'#305' Seri No Listesi'
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    Transparent = True
  end
  object Panel1: TPanel
    Left = 8
    Top = 8
    Width = 235
    Height = 130
    BevelInner = bvRaised
    BevelOuter = bvLowered
    TabOrder = 0
    object Label1: TLabel
      Left = 8
      Top = 12
      Width = 30
      Height = 14
      Caption = 'Fi'#351' No'
      Transparent = True
    end
    object Label2: TLabel
      Left = 8
      Top = 37
      Width = 23
      Height = 14
      Caption = 'Tarih'
      Transparent = True
    end
    object Label3: TLabel
      Left = 8
      Top = 59
      Width = 22
      Height = 14
      Caption = 'Saat'
      Transparent = True
    end
    object Label4: TLabel
      Left = 8
      Top = 81
      Width = 43
      Height = 14
      Caption = 'Belge No'
      Transparent = True
    end
    object LCarkod: TLabel
      Left = 8
      Top = 104
      Width = 44
      Height = 14
      Caption = 'Firma Ad'#305
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      Transparent = True
    end
    object LTutanak: TLabel
      Left = 6
      Top = 75
      Width = 55
      Height = 26
      AutoSize = False
      Caption = 'Belge No Tutanak No'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      Transparent = True
      Visible = False
      WordWrap = True
    end
    object FisNok: TDBEdit
      Left = 64
      Top = 8
      Width = 91
      Height = 22
      TabStop = False
      Color = clBtnFace
      DataField = 'id'
      DataSource = StokFisiQS
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      ReadOnly = True
      TabOrder = 0
    end
    object Tarihk: TwwDBDateTimePicker
      Left = 64
      Top = 31
      Width = 92
      Height = 22
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      DataField = 'tarih'
      DataSource = StokFisiQS
      Epoch = 1950
      ShowButton = True
      TabOrder = 2
    end
    object saatk: TDBEdit
      Left = 64
      Top = 54
      Width = 48
      Height = 22
      DataField = 'saat'
      DataSource = StokFisiQS
      TabOrder = 3
    end
    object belgenok: TDBEdit
      Left = 64
      Top = 77
      Width = 165
      Height = 22
      DataField = 'belgeno'
      DataSource = StokFisiQS
      MaxLength = 17
      TabOrder = 4
    end
    object DBEdit2: TDBEdit
      Left = 156
      Top = 8
      Width = 75
      Height = 22
      TabStop = False
      Color = clBtnFace
      DataField = 'Tipi'
      DataSource = StokFisiQS
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      ReadOnly = True
      TabOrder = 7
    end
    object CarKod: TwwDBComboDlg
      Tag = 20000
      Left = 64
      Top = 100
      Width = 167
      Height = 22
      ShowButton = True
      Style = csDropDown
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 6
      WordWrap = False
      UnboundDataType = wwDefault
      OnExit = CarKodExit
    end
    object Tutanak: TwwDBComboBox
      Left = 157
      Top = 8
      Width = 75
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DataField = 'Tipi'
      DataSource = StokFisiQS
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'TUTANAK'#9'TUTANAK')
      Sorted = False
      TabOrder = 1
      UnboundDataType = wwDefault
      Visible = False
      OnChange = TutanakChange
    end
    object cbTutanak: TwwDBLookupCombo
      Left = 64
      Top = 77
      Width = 168
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      DataField = 'belgeno'
      DataSource = StokFisiQS
      LookupTable = adoTutanakTanim
      LookupField = 'Adi'
      Navigator = False
      TabOrder = 5
      Visible = False
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
    end
  end
  object Panel2: TPanel
    Left = 245
    Top = 8
    Width = 781
    Height = 130
    Anchors = [akLeft, akTop, akRight]
    BevelInner = bvRaised
    BevelOuter = bvLowered
    TabOrder = 1
    DesignSize = (
      781
      130)
    object ozelkodl: TLabel
      Left = 8
      Top = 11
      Width = 44
      Height = 14
      Caption = #214'zel Kod'
      Transparent = True
    end
    object girisambaril: TLabel
      Left = 8
      Top = 58
      Width = 58
      Height = 14
      Caption = 'Giri'#351' Ambar'#305
      Transparent = True
    end
    object cikisambaril: TLabel
      Left = 8
      Top = 34
      Width = 58
      Height = 14
      Caption = #199#305'k'#305#351' Ambar'#305
      Transparent = True
    end
    object aciklamal: TLabel
      Left = 8
      Top = 82
      Width = 43
      Height = 14
      Caption = 'A'#231#305'klama'
      Transparent = True
    end
    object Label5: TLabel
      Left = 248
      Top = 12
      Width = 69
      Height = 14
      Caption = #220'retim Emri No'
      Transparent = True
    end
    object Label10: TLabel
      Left = 248
      Top = 34
      Width = 63
      Height = 14
      Caption = 'Unity Emir No'
      Transparent = True
    end
    object ozelkodk: TDBEdit
      Left = 80
      Top = 8
      Width = 105
      Height = 22
      DataField = 'Ozelkod1'
      DataSource = StokFisiQS
      TabOrder = 0
    end
    object girisambarik: TwwDBLookupCombo
      Left = 80
      Top = 54
      Width = 145
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'DepoAdi'#9'20'#9'Depo Ad'#305#9'F'#9)
      DataField = 'gambar'
      DataSource = StokFisiQS
      LookupTable = dm.AmbarQ
      LookupField = 'id'
      Style = csDropDownList
      Navigator = False
      TabOrder = 2
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      OnCloseUp = cikisambarikCloseUp
    end
    object cikisambarik: TwwDBLookupCombo
      Left = 80
      Top = 31
      Width = 145
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'DepoAdi'#9'20'#9'Depo Ad'#305#9#9)
      DataField = 'cambar'
      DataSource = StokFisiQS
      LookupTable = dm.AmbarQ
      LookupField = 'id'
      Style = csDropDownList
      Navigator = False
      TabOrder = 1
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      OnCloseUp = cikisambarikCloseUp
    end
    object aciklamak: TDBEdit
      Left = 80
      Top = 77
      Width = 527
      Height = 22
      Anchors = [akLeft, akTop, akRight]
      DataField = 'aciklama'
      DataSource = StokFisiQS
      TabOrder = 3
    end
    object DBEdit1: TDBEdit
      Left = 328
      Top = 8
      Width = 105
      Height = 22
      DataField = 'UretimEmriNo'
      DataSource = StokFisiQS
      Enabled = False
      TabOrder = 4
    end
    object pnl_IRSNO: TPanel
      Left = 475
      Top = 7
      Width = 197
      Height = 37
      TabOrder = 5
      Visible = False
      object Label8: TLabel
        Left = 7
        Top = 11
        Width = 50
        Height = 14
        Caption = #304'rsaliye No'
        Transparent = True
      end
      object edIrsNo: TDBEdit
        Left = 85
        Top = 7
        Width = 105
        Height = 22
        DataField = 'IRSNO'
        DataSource = StokFisiQS
        TabOrder = 0
      end
    end
    object DBEdit3: TDBEdit
      Left = 328
      Top = 31
      Width = 105
      Height = 22
      DataField = 'unityemirno'
      DataSource = StokFisiQS
      Enabled = False
      TabOrder = 6
    end
    object cbStokEtkileme: TwwCheckBox
      Left = 8
      Top = 103
      Width = 88
      Height = 17
      DisableThemes = False
      AlwaysTransparent = False
      ValueChecked = 'True'
      ValueUnchecked = 'False'
      DisplayValueChecked = 'True'
      DisplayValueUnchecked = 'False'
      NullAndBlankState = cbUnchecked
      Alignment = taLeftJustify
      Caption = 'Sto'#287'u Etkileme'
      DataField = 'StokEtkileme'
      DataSource = StokFisiQS
      TabOrder = 7
      Visible = False
      ReadOnly = True
    end
  end
  object Grid1: TwwDBGrid
    Left = 9
    Top = 142
    Width = 782
    Height = 416
    DisableThemes = False
    ControlType.Strings = (
      'stokkodu;CustomEdit;StokKoduk;T'
      'cinsi;CustomEdit;CinsiK;T'
      'islem;CustomEdit;islemtipik;T'
      'cambar;CustomEdit;lcCAMBAR;T'
      'gambar;CustomEdit;lcGAmbar;T')
    Selected.Strings = (
      'islem'#9'7'#9#304#351'lem'#9'F'
      'stokkodu'#9'22'#9'Stok Kodu'#9#9
      'cinsi'#9'35'#9'Cinsi'#9'F'#9
      'miktar'#9'8'#9'Miktar'#9'F'
      'aciklama'#9'20'#9'A'#231#305'klama'#9'F'
      'cambar'#9'13'#9#199'.Ambar'#9'T'
      'gambar'#9'13'#9'G.Ambar'#9'T'
      'Okutulan'#9'10'#9'Okutulan'#9'T')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Anchors = [akLeft, akTop, akRight, akBottom]
    Constraints.MinHeight = 200
    DataSource = StokFisiHarQS
    KeyOptions = [dgEnterToTab, dgAllowDelete, dgAllowInsert]
    TabOrder = 2
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = True
    UseTFields = False
    OnTitleButtonClick = Grid1TitleButtonClick
  end
  object StokKoduk: TwwDBComboDlg
    Tag = 1
    Left = 24
    Top = 184
    Width = 136
    Height = 22
    ShowButton = True
    Style = csDropDown
    TabOrder = 3
    WordWrap = False
    UnboundDataType = wwDefault
    OnExit = StokKodubul
  end
  object CinsiK: TwwDBComboDlg
    Tag = 2
    Left = 200
    Top = 184
    Width = 214
    Height = 22
    ShowButton = True
    Style = csDropDown
    TabOrder = 4
    WordWrap = False
    UnboundDataType = wwDefault
    OnExit = StokKodubul
  end
  object SeriNolListek: TListBox
    Left = 424
    Top = 168
    Width = 97
    Height = 57
    ItemHeight = 14
    TabOrder = 5
    Visible = False
  end
  object islemtipik: TwwDBComboBox
    Left = 23
    Top = 217
    Width = 41
    Height = 22
    ShowButton = True
    Style = csDropDownList
    MapList = True
    AllowClearKey = True
    AutoDropDown = True
    DropDownCount = 8
    ItemHeight = 0
    Items.Strings = (
      'Giri'#351#9'+'
      #199#305'k'#305#351#9'-')
    Sorted = False
    TabOrder = 6
    UnboundDataType = wwDefault
    OnCloseUp = islemtipikCloseUp
  end
  object Panel3: TPanel
    Left = 0
    Top = 560
    Width = 1002
    Height = 36
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 7
    DesignSize = (
      1002
      36)
    object Label7: TLabel
      Left = 271
      Top = 14
      Width = 71
      Height = 14
      Caption = 'Toplam Sat'#305'r:'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object lblSatir: TLabel
      Left = 344
      Top = 14
      Width = 49
      Height = 17
      Alignment = taCenter
      AutoSize = False
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object lblAdet: TLabel
      Left = 478
      Top = 14
      Width = 49
      Height = 17
      Alignment = taCenter
      AutoSize = False
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object Label9: TLabel
      Left = 405
      Top = 14
      Width = 72
      Height = 14
      Caption = 'Toplam Adet:'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object bkaydet: TBitBtn
      Left = 8
      Top = 8
      Width = 89
      Height = 25
      Caption = '&Kaydet'
      TabOrder = 0
      OnClick = bkaydetClick
    end
    object bvazgec: TBitBtn
      Left = 104
      Top = 8
      Width = 89
      Height = 25
      Caption = '&Vazge'#231
      TabOrder = 1
      OnClick = bvazgecClick
    end
    object bkapat: TBitBtn
      Left = 892
      Top = 4
      Width = 93
      Height = 25
      Anchors = [akTop, akRight]
      Caption = '&Kapat'
      TabOrder = 2
      OnClick = bkapatClick
    end
    object bSeriNogir: TButton
      Left = 593
      Top = 6
      Width = 75
      Height = 25
      Caption = 'SeriNo Gir'
      TabOrder = 3
      Visible = False
      OnClick = bSeriNogirClick
    end
    object bserinogir2: TButton
      Left = 673
      Top = 7
      Width = 75
      Height = 25
      Caption = 'SeriNo Gir'
      TabOrder = 4
      Visible = False
      OnClick = bserinogir2Click
    end
  end
  object Ltop: TListBox
    Left = 200
    Top = 224
    Width = 105
    Height = 113
    ItemHeight = 14
    TabOrder = 8
    Visible = False
  end
  object M: TMemo
    Left = 794
    Top = 157
    Width = 221
    Height = 226
    Anchors = [akTop, akRight]
    ScrollBars = ssBoth
    TabOrder = 9
  end
  object lcGAmbar: TwwDBLookupCombo
    Left = 325
    Top = 257
    Width = 82
    Height = 22
    DisableThemes = False
    DropDownAlignment = taLeftJustify
    Selected.Strings = (
      'DepoAdi'#9'20'#9'Depo Ad'#305#9#9)
    LookupTable = dm.AmbarQ
    LookupField = 'id'
    Style = csDropDownList
    Navigator = False
    ReadOnly = True
    TabOrder = 10
    AutoDropDown = True
    ShowButton = True
    UseTFields = False
    AllowClearKey = True
  end
  object lcCAMBAR: TwwDBLookupCombo
    Left = 325
    Top = 283
    Width = 82
    Height = 22
    DisableThemes = False
    DropDownAlignment = taLeftJustify
    Selected.Strings = (
      'DepoAdi'#9'20'#9'Depo Ad'#305#9#9)
    LookupTable = dm.AmbarQ
    LookupField = 'id'
    Style = csDropDownList
    Navigator = False
    ReadOnly = True
    TabOrder = 11
    AutoDropDown = True
    ShowButton = True
    UseTFields = False
    AllowClearKey = True
  end
  object grdStokFisiharhar: TwwDBGrid
    Left = 794
    Top = 384
    Width = 223
    Height = 134
    DisableThemes = False
    Selected.Strings = (
      'Serino'#9'18'#9'Serino'#9'F'
      'YSerino'#9'18'#9'Y.Serino'#9'F'
      'RefNo'#9'10'#9'Ref.No'#9'F')
    IniAttributes.Enabled = True
    IniAttributes.Delimiter = ';;'
    ExportOptions.Options = [esoShowHeader, esoShowFooter, esoDynamicColors, esoShowTitle, esoDblQuoteFields, esoShowAlternating, esoTransparentGrid]
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Anchors = [akTop, akRight]
    DataSource = StokFisiharharQs
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clBlack
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = []
    KeyOptions = [dgEnterToTab]
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgCancelOnExit, dgWordWrap, dgTabExitsOnLastCol]
    ParentFont = False
    PopupMenu = PmSeriNo
    ReadOnly = True
    TabOrder = 12
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clMaroon
    TitleFont.Height = -11
    TitleFont.Name = 'Microsoft Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = True
    UseTFields = False
    FooterColor = 14978657
    FooterCellColor = 13948116
    PaintOptions.AlternatingRowColor = 16310998
    PaintOptions.ActiveRecordColor = 15183770
  end
  object StokFisiQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    BeforePost = StokFisiQBeforePost
    Parameters = <>
    SQL.Strings = (
      'Select * from StokFisi where id is null')
    Left = 552
    Top = 144
  end
  object StokFisiQS: TDataSource
    DataSet = StokFisiQ
    Left = 512
    Top = 144
  end
  object StokFisiHarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    AfterOpen = StokFisiHarQAfterOpen
    BeforePost = StokFisiHarQBeforePost
    AfterPost = StokFisiHarQAfterOpen
    AfterCancel = StokFisiHarQAfterCancel
    BeforeDelete = StokFisiHarQBeforeDelete
    AfterDelete = StokFisiHarQAfterDelete
    AfterScroll = StokFisiHarQAfterScroll
    AfterRefresh = StokFisiHarQAfterScroll
    Parameters = <>
    SQL.Strings = (
      'Select * from StokFisiHar where id is null')
    Left = 552
    Top = 184
  end
  object StokFisiHarQS: TDataSource
    DataSet = StokFisiHarQ
    Left = 512
    Top = 184
  end
  object StokBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'serinos'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end>
    SQL.Strings = (
      
        'select Serino=Serinos,stokkod,stokkodu=(select stokkodu from sto' +
        'k where stok.stokkod=fatharhar.stokkod),cinsi=(select cinsi from' +
        ' stok where stok.stokkod=fatharhar.stokkod) '
      'from fatharhar where serinos=:serinos')
    Left = 552
    Top = 224
  end
  object MainMenu1: TMainMenu
    Left = 136
    Top = 352
    object Kayt1: TMenuItem
      Caption = 'Kay'#305't'
      object Kaydet1: TMenuItem
        Caption = 'Kaydet'
        ShortCut = 113
        OnClick = Kaydet1Click
      end
      object Vazgec1: TMenuItem
        Caption = 'Vazge'#231
        ShortCut = 117
        OnClick = Vazgec1Click
      end
      object N1: TMenuItem
        Caption = '-'
      end
      object opluSeriNoGir1: TMenuItem
        Caption = 'Toplu Seri No Gir'
        ShortCut = 121
        OnClick = opluSeriNoGir1Click
      end
      object SeriNoGir1: TMenuItem
        Caption = 'Seri No Gir'
        ShortCut = 122
        OnClick = SeriNoGir1Click
      end
      object Yazdr1: TMenuItem
        Caption = 'Yazd'#305'r'
        ShortCut = 123
        OnClick = Yazdr1Click
      end
      object Sipariar1: TMenuItem
        Caption = 'Sipari'#351' '#199'a'#287#305'r'
        OnClick = Sipariar1Click
      end
    end
  end
  object UretimBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'makinano1'
        Size = -1
        Value = Null
      end
      item
        Name = 'makinano2'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'select stokkod,stokkodu,cinsi,1 as miktar from uremrihar '
      
        'where emirno=(select uretimno from uretim where makinano=:makina' +
        'no1)'
      
        'and isnull(degisim,0)<>2 and yapilan is null and stokkod<>0 and ' +
        'stokkod is not null'
      'union'
      
        'select stokkod,stokkodu=(select stokkodu from stok where stok.st' +
        'okkod=fatharhar.stokkod),cinsi=(select cinsi from stok where sto' +
        'k.stokkod=fatharhar.stokkod),count(stokkod) as miktar from fatha' +
        'rhar'
      'where makinano=:makinano2 and stokkod<>0 and stokkod is not null'
      'group by stokkod')
    Left = 552
    Top = 264
  end
  object UretimParcalaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'makinano1'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'makinano2'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end>
    SQL.Strings = (
      'update fatharhar'
      
        'set makinano=null,bilisnocik=null,verilengaranti=null,siracik=nu' +
        'll'
      'where makinano=:makinano1'
      ''
      'delete fatharhar'
      'where serinos=:makinano2')
    Left = 552
    Top = 296
  end
  object AramaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'id'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      
        'select FisTuru=(select fisadi from P_StokFisi_Fisadi where P_Sto' +
        'kFisi_FisAdi.FisTipi=StokFisi.FisTipi),'
      
        '       l_gAmbar=(select Depoadi from Depolar where Depolar.id=St' +
        'okFisi.gambar),'
      
        '       l_cAmbar=(select Depoadi from Depolar where Depolar.id=St' +
        'okFisi.cambar),'
      '* from StokFisi'
      'where id=:id'
      '')
    Left = 384
    Top = 248
  end
  object ppAramaQ: TppDBPipeline
    DataSource = AramaQS
    AutoCreateFields = False
    UserName = 'AramaQ'
    Left = 424
    Top = 248
    object ppDBPipeline1ppField1: TppField
      FieldAlias = 'FisTuru'
      FieldName = 'FisTuru'
      FieldLength = 20
      DisplayWidth = 20
      Position = 0
    end
    object ppDBPipeline1ppField2: TppField
      FieldAlias = 'l_gAmbar'
      FieldName = 'l_gAmbar'
      FieldLength = 20
      DisplayWidth = 20
      Position = 1
    end
    object ppDBPipeline1ppField3: TppField
      FieldAlias = 'l_cAmbar'
      FieldName = 'l_cAmbar'
      FieldLength = 20
      DisplayWidth = 20
      Position = 2
    end
    object ppDBPipeline1ppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'id'
      FieldName = 'id'
      FieldLength = 0
      DataType = dtLongint
      DisplayWidth = 10
      Position = 3
    end
    object ppDBPipeline1ppField5: TppField
      FieldAlias = 'fistipi'
      FieldName = 'fistipi'
      FieldLength = 2
      DisplayWidth = 2
      Position = 4
    end
    object ppDBPipeline1ppField6: TppField
      FieldAlias = 'tarih'
      FieldName = 'tarih'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 5
    end
    object ppDBPipeline1ppField7: TppField
      FieldAlias = 'saat'
      FieldName = 'saat'
      FieldLength = 5
      DisplayWidth = 5
      Position = 6
    end
    object ppDBPipeline1ppField8: TppField
      FieldAlias = 'belgeno'
      FieldName = 'belgeno'
      FieldLength = 20
      DisplayWidth = 20
      Position = 7
    end
    object ppDBPipeline1ppField9: TppField
      FieldAlias = 'ozelkod'
      FieldName = 'ozelkod'
      FieldLength = 10
      DisplayWidth = 10
      Position = 8
    end
    object ppDBPipeline1ppField10: TppField
      FieldAlias = 'aciklama'
      FieldName = 'aciklama'
      FieldLength = 100
      DisplayWidth = 100
      Position = 9
    end
    object ppDBPipeline1ppField11: TppField
      Alignment = taRightJustify
      FieldAlias = 'gambar'
      FieldName = 'gambar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 10
    end
    object ppDBPipeline1ppField12: TppField
      Alignment = taRightJustify
      FieldAlias = 'cambar'
      FieldName = 'cambar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 11
    end
    object ppDBPipeline1ppField13: TppField
      FieldAlias = 'UretimEmriNo'
      FieldName = 'UretimEmriNo'
      FieldLength = 10
      DisplayWidth = 10
      Position = 12
    end
  end
  object AramaQS: TDataSource
    DataSet = AramaQ
    Left = 344
    Top = 248
  end
  object ppStokFisiHarQ: TppDBPipeline
    DataSource = StokFisiHarQS
    AutoCreateFields = False
    UserName = 'StokFisiHarQ'
    Left = 424
    Top = 280
    object ppStokFisiHarQppField1: TppField
      Alignment = taRightJustify
      FieldAlias = 'id'
      FieldName = 'id'
      FieldLength = 0
      DataType = dtLongint
      DisplayWidth = 10
      Position = 0
    end
    object ppStokFisiHarQppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'Stokfisiid'
      FieldName = 'Stokfisiid'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
    object ppStokFisiHarQppField3: TppField
      Alignment = taRightJustify
      FieldAlias = 'stokkod'
      FieldName = 'stokkod'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 2
    end
    object ppStokFisiHarQppField4: TppField
      FieldAlias = 'stokkodu'
      FieldName = 'stokkodu'
      FieldLength = 25
      DisplayWidth = 25
      Position = 3
    end
    object ppStokFisiHarQppField5: TppField
      FieldAlias = 'cinsi'
      FieldName = 'cinsi'
      FieldLength = 50
      DisplayWidth = 50
      Position = 4
    end
    object ppStokFisiHarQppField6: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 5
    end
    object ppStokFisiHarQppField7: TppField
      FieldAlias = 'aciklama'
      FieldName = 'aciklama'
      FieldLength = 50
      DisplayWidth = 50
      Position = 6
    end
    object ppStokFisiHarQppField8: TppField
      FieldAlias = 'islem'
      FieldName = 'islem'
      FieldLength = 1
      DisplayWidth = 1
      Position = 7
    end
    object ppStokFisiHarQppField9: TppField
      Alignment = taRightJustify
      FieldAlias = 'gambar'
      FieldName = 'gambar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 8
    end
    object ppStokFisiHarQppField10: TppField
      Alignment = taRightJustify
      FieldAlias = 'cambar'
      FieldName = 'cambar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 9
    end
  end
  object RapFisYazdir: TppReport
    AutoStop = False
    DataPipeline = ppStokFisiHarQ
    OnPrintingComplete = RapFisYazdirPrintingComplete
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'Custom'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 256
    Units = utMillimeters
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 464
    Top = 280
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppStokFisiHarQ'
    object ppTitleBand1: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 52123
      mmPrintPosition = 0
      object ppLabel1: TppLabel
        UserName = 'Label1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Fi'#351' No   :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 8467
        mmTop = 26458
        mmWidth = 21167
        BandType = 1
      end
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'id'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3704
        mmLeft = 31221
        mmTop = 26458
        mmWidth = 17198
        BandType = 1
      end
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'FisTuru'
        DataPipeline = ppAramaQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 16
        Font.Style = []
        ParentDataPipeline = False
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 6615
        mmLeft = 76200
        mmTop = 26194
        mmWidth = 39423
        BandType = 1
      end
      object ppLabel3: TppLabel
        UserName = 'Label3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'G.Ambar  :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 8467
        mmTop = 35983
        mmWidth = 21167
        BandType = 1
      end
      object ppDBText3: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'l_gAmbar'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3704
        mmLeft = 31221
        mmTop = 35190
        mmWidth = 39423
        BandType = 1
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #199'.Ambar  :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 8467
        mmTop = 31485
        mmWidth = 21167
        BandType = 1
      end
      object ppDBText4: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'l_cAmbar'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3969
        mmLeft = 31221
        mmTop = 30956
        mmWidth = 39423
        BandType = 1
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Tarih :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 147109
        mmTop = 26458
        mmWidth = 14817
        BandType = 1
      end
      object ppDBText5: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'tarih'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3704
        mmLeft = 164571
        mmTop = 26194
        mmWidth = 25929
        BandType = 1
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Saat  :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 147109
        mmTop = 32015
        mmWidth = 14817
        BandType = 1
      end
      object ppDBText6: TppDBText
        UserName = 'DBText6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'saat'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3704
        mmLeft = 164571
        mmTop = 31485
        mmWidth = 18785
        BandType = 1
      end
      object ppLabel11: TppLabel
        UserName = 'Label11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'A'#231#305'klama :'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 8467
        mmTop = 40481
        mmWidth = 21167
        BandType = 1
      end
      object ppDBText11: TppDBText
        UserName = 'DBText11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'aciklama'
        DataPipeline = ppAramaQ
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = 'ppAramaQ'
        mmHeight = 3969
        mmLeft = 31221
        mmTop = 40217
        mmWidth = 134409
        BandType = 1
      end
    end
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 5292
      mmPrintPosition = 0
      object ppLabel7: TppLabel
        UserName = 'Label7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3429
        mmLeft = 7938
        mmTop = 529
        mmWidth = 15346
        BandType = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Cinsi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3429
        mmLeft = 56092
        mmTop = 529
        mmWidth = 5800
        BandType = 0
      end
      object ppLabel9: TppLabel
        UserName = 'Label9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Miktar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3429
        mmLeft = 113771
        mmTop = 529
        mmWidth = 7662
        BandType = 0
      end
      object ppLabel10: TppLabel
        UserName = 'Label10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'A'#231#305'klama'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3440
        mmLeft = 123031
        mmTop = 529
        mmWidth = 11113
        BandType = 0
      end
      object ppLine1: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 265
        mmLeft = 6350
        mmTop = 4498
        mmWidth = 187855
        BandType = 0
      end
    end
    object ppDetailBand1: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 6350
      mmPrintPosition = 0
      object ppDBText7: TppDBText
        UserName = 'DBText7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppStokFisiHarQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppStokFisiHarQ'
        mmHeight = 3429
        mmLeft = 7408
        mmTop = 1058
        mmWidth = 47096
        BandType = 4
      end
      object ppDBText8: TppDBText
        UserName = 'DBText8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppStokFisiHarQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppStokFisiHarQ'
        mmHeight = 3440
        mmLeft = 55827
        mmTop = 1058
        mmWidth = 51858
        BandType = 4
      end
      object ppDBText9: TppDBText
        UserName = 'DBText9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppStokFisiHarQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppStokFisiHarQ'
        mmHeight = 3440
        mmLeft = 110331
        mmTop = 1058
        mmWidth = 11113
        BandType = 4
      end
      object ppDBText10: TppDBText
        UserName = 'DBText10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'aciklama'
        DataPipeline = ppStokFisiHarQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Tahoma'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppStokFisiHarQ'
        mmHeight = 3440
        mmLeft = 122767
        mmTop = 1058
        mmWidth = 71173
        BandType = 4
      end
      object ppLine2: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 265
        mmLeft = 6350
        mmTop = 5027
        mmWidth = 187855
        BandType = 4
      end
    end
    object ppSummaryBand1: TppSummaryBand
      mmBottomOffset = 0
      mmHeight = 19315
      mmPrintPosition = 0
      object ppLabel12: TppLabel
        UserName = 'Label12'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Teslim Alan'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 71967
        mmTop = 3175
        mmWidth = 23283
        BandType = 7
      end
      object ppLabel13: TppLabel
        UserName = 'Label13'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Teslim Eden'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 8467
        mmTop = 3175
        mmWidth = 23283
        BandType = 7
      end
      object ppLabel2: TppLabel
        UserName = 'Label2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Onaylayan'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Courier New'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3739
        mmLeft = 138642
        mmTop = 2646
        mmWidth = 19050
        BandType = 7
      end
    end
    object ppParameterList1: TppParameterList
    end
  end
  object GeciciQ: TADOQuery
    Connection = dm.connect
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'FisID'
        DataType = ftInteger
        Size = -1
        Value = 1
      end>
    SQL.Strings = (
      
        'Create Table #Gecici (stokkod int,stokkodu varchar(25),ambarid s' +
        'mallint,eski int,simdi int,gercekadet int)'
      ''
      'insert into #gecici (stokkod,stokkodu,ambarid,eski)'
      
        'select stokkod,stokkodu=dbo.getstokkodu(stokkod),cambar,sum(mikt' +
        'ar) as eski from stokfisihar'
      'where stokfisiid=:FisID'
      'group by stokkod,cambar'
      ''
      'Select * from #gecici'
      ''
      'drop table #gecici')
    Left = 672
    Top = 144
  end
  object Unity_SiparisharQ: TADOQuery
    Connection = dm.connect
    Parameters = <
      item
        Name = 'siparisno'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      
        'select stokkod,stokkodu=dbo.getstokkodu(stokkod),cinsi=dbo.getci' +
        'nsi(stokkod),miktar from unity_siparishar_2006'
      'where siparisid'
      'in'
      '('
      'select id from unity_siparis_2006 where siparisno=:siparisno'
      ')')
    Left = 672
    Top = 184
  end
  object GeciciStokQ: TADOQuery
    Connection = dm.connect
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'FisID'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 1
      end>
    SQL.Strings = (
      'select stokkod,miktar,islem,gambar,cambar from stokfisihar'
      'where stokfisiid=:FisID')
    Left = 712
    Top = 144
  end
  object Casper_StokTakipQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    Left = 672
    Top = 232
  end
  object StokUpdateQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    Left = 672
    Top = 264
  end
  object OD: TOpenDialog
    DefaultExt = 'TXT'
    Filter = 'Metin Dosyas'#305'|*.txt'
    Title = 'Toplu Seri No Dosyas'#305
    Left = 224
    Top = 360
  end
  object adoTutanakTanim: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select * from TutanakTanim')
    Left = 552
    Top = 352
  end
  object StokFisiharharQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'Select * from StokFisiHarHar where id is null')
    Left = 694
    Top = 342
  end
  object StokFisiharharQs: TDataSource
    DataSet = StokFisiharharQ
    Left = 654
    Top = 342
  end
  object PmSeriNo: TPopupMenu
    OnPopup = PmSeriNoPopup
    Left = 422
    Top = 410
    object Sil1: TMenuItem
      Caption = 'Sil'
      OnClick = Sil1Click
    end
  end
  object aqSeriNoDuzelt: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'Select * from TblSeriNoDuzelt')
    Left = 333
    Top = 385
  end
end
